Pandas Profiling Report

Dataset statistics

Number of variables	29
Number of observations	554822
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	89598
Duplicate rows (%)	16.1%
Total size in memory	122.8 MiB
Average record size in memory	232.0 B

Variable types

Numeric	19
Categorical	10

Alerts

Dataset has 89598 (16.1%) duplicate rows	Duplicates
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking`	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of _week_first_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of _week_first_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of _year_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 1 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 1 other fields	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of _week_first_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of _week_first_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of _year_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking`	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of _week_first_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of _week_first_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of _year_first_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`first_browser` is highly correlated with `first_device_type`	High correlation
`first_device_type` is highly correlated with `first_browser` and 1 other fields	High correlation
`affiliate_channel` is highly correlated with `affiliate_provider`	High correlation
`signup_app` is highly correlated with `first_device_type`	High correlation
`affiliate_provider` is highly correlated with `affiliate_channel`	High correlation
`signup_flow` is highly correlated with `affiliate_channel` and 3 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 4 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 6 other fields	High correlation
`year_first_active` is highly correlated with `days_from_account_created_until_first_booking` and 6 other fields	High correlation
`month_first_active` is highly correlated with `year_first_active` and 6 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`day_of_week_first_active` is highly correlated with `day_of _week_first_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `year_first_active` and 6 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 6 other fields	High correlation
`month_first_booking` is highly correlated with `days_from_first_active_until_booking` and 7 other fields	High correlation
`day_first_booking` is highly correlated with `days_from_first_active_until_booking` and 5 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 8 other fields	High correlation
`year_account_created` is highly correlated with `days_from_account_created_until_first_booking` and 6 other fields	High correlation
`month_account_created` is highly correlated with `year_first_active` and 6 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`day_of _week_first_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of _year_first_account_created` is highly correlated with `year_first_active` and 6 other fields	High correlation
`affiliate_channel` is highly correlated with `signup_flow` and 3 other fields	High correlation
`affiliate_provider` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_affiliate_tracked` is highly correlated with `affiliate_channel` and 1 other fields	High correlation
`signup_app` is highly correlated with `signup_flow` and 3 other fields	High correlation
`first_device_type` is highly correlated with `signup_app` and 1 other fields	High correlation
`first_browser` is highly correlated with `signup_flow` and 2 other fields	High correlation
`days_from_first_active_until_account_created` is highly skewed (γ1 = 67.77477362)	Skewed
`signup_flow` has 441238 (79.5%) zeros	Zeros
`days_from_first_active_until_booking` has 122446 (22.1%) zeros	Zeros
`days_from_first_active_until_account_created` has 553802 (99.8%) zeros	Zeros
`days_from_account_created_until_first_booking` has 122379 (22.1%) zeros	Zeros
`day_of_week_first_active` has 86787 (15.6%) zeros	Zeros
`day_of_week_first_booking` has 124075 (22.4%) zeros	Zeros
`day_of _week_first_account_created` has 86744 (15.6%) zeros	Zeros

Reproduction

Analysis started	2022-07-22 14:01:59.557762
Analysis finished	2022-07-22 14:08:12.378882
Duration	6 minutes and 12.82 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

age
Real number (ℝ_≥0)

Distinct	99
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.77970232

Minimum	16
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	16
5-th percentile	23
Q1	28
median	33
Q3	41
95-th percentile	61
Maximum	115
Range	99
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	13.17440626
Coefficient of variation (CV)	0.3581977402
Kurtosis	6.791570217
Mean	36.77970232
Median Absolute Deviation (MAD)	6
Skewness	2.111487904
Sum	20406188
Variance	173.5649802
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	30377	5.5%
31	30259	5.5%
29	29160	5.3%
32	28602	5.2%
28	27287	4.9%
33	26616	4.8%
27	24571	4.4%
34	23755	4.3%
35	22384	4.0%
26	21436	3.9%
Other values (89)	290375	52.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	26	< 0.1%
17	74	< 0.1%
18	1698	0.3%
19	3720	0.7%
20	2777	0.5%
21	4907	0.9%
22	8583	1.5%
23	11942	2.2%
24	14952	2.7%
25	19088	3.4%

Value	Count	Frequency (%)
115	12	< 0.1%
113	4	< 0.1%
112	1	< 0.1%
111	2	< 0.1%
110	191	< 0.1%
109	103	< 0.1%
108	76	< 0.1%
107	86	< 0.1%
106	74	< 0.1%
105	4126	0.7%

signup_flow
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.729837678

Minimum	0
Maximum	25
Zeros	441238
Zeros (%)	79.5%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	14
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.296777675
Coefficient of variation (CV)	3.062008502
Kurtosis	11.42426557
Mean	1.729837678
Median Absolute Deviation (MAD)	0
Skewness	3.516556698
Sum	959752
Variance	28.05585374
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	441238	79.5%
1	28587	5.2%
2	23251	4.2%
25	11500	2.1%
3	9959	1.8%
12	8254	1.5%
24	6593	1.2%
23	2840	0.5%
5	2139	0.4%
6	2036	0.4%
Other values (16)	18425	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	441238	79.5%
1	28587	5.2%
2	23251	4.2%
3	9959	1.8%
4	2027	0.4%
5	2139	0.4%
6	2036	0.4%
7	1827	0.3%
8	1841	0.3%
9	1668	0.3%

Value	Count	Frequency (%)
25	11500	2.1%
24	6593	1.2%
23	2840	0.5%
22	841	0.2%
21	1045	0.2%
20	699	0.1%
19	734	0.1%
18	710	0.1%
17	709	0.1%
16	712	0.1%

days_from_first_active_until_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1853
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.3910011

Minimum	0
Maximum	2228
Zeros	122446
Zeros (%)	22.1%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	103
95-th percentile	667
Maximum	2228
Range	2228
Interquartile range (IQR)	102

Descriptive statistics

Standard deviation	240.110073
Coefficient of variation (CV)	2.080838807
Kurtosis	9.851641831
Mean	115.3910011
Median Absolute Deviation (MAD)	6
Skewness	2.981158886
Sum	64021466
Variance	57652.84716
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122446	22.1%
1	70338	12.7%
2	32712	5.9%
3	20939	3.8%
4	15445	2.8%
5	11768	2.1%
6	10431	1.9%
7	9028	1.6%
8	7749	1.4%
9	6119	1.1%
Other values (1843)	247847	44.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	122446	22.1%
1	70338	12.7%
2	32712	5.9%
3	20939	3.8%
4	15445	2.8%
5	11768	2.1%
6	10431	1.9%
7	9028	1.6%
8	7749	1.4%
9	6119	1.1%

Value	Count	Frequency (%)
2228	1	< 0.1%
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%

days_from_first_active_until_account_created
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	324
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2266384534

Minimum	0
Maximum	1456
Zeros	553802
Zeros (%)	99.8%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1456
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.22598719
Coefficient of variation (CV)	45.12026549
Kurtosis	5722.187389
Mean	0.2266384534
Median Absolute Deviation (MAD)	0
Skewness	67.77477362
Sum	125744
Variance	104.570814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	553802	99.8%
2	104	< 0.1%
1	91	< 0.1%
3	70	< 0.1%
4	56	< 0.1%
5	18	< 0.1%
6	15	< 0.1%
16	11	< 0.1%
11	10	< 0.1%
10	9	< 0.1%
Other values (314)	636	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	553802	99.8%
1	91	< 0.1%
2	104	< 0.1%
3	70	< 0.1%
4	56	< 0.1%
5	18	< 0.1%
6	15	< 0.1%
7	7	< 0.1%
8	7	< 0.1%
9	9	< 0.1%

Value	Count	Frequency (%)
1456	1	< 0.1%
1369	1	< 0.1%
1361	1	< 0.1%
1148	1	< 0.1%
1036	1	< 0.1%
1011	1	< 0.1%
1006	1	< 0.1%
991	1	< 0.1%
984	1	< 0.1%
968	1	< 0.1%

days_from_account_created_until_first_booking
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1973
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.163858

Minimum	-349
Maximum	2001
Zeros	122379
Zeros (%)	22.1%
Negative	240
Negative (%)	< 0.1%
Memory size	4.2 MiB

Quantile statistics

Minimum	-349
5-th percentile	0
Q1	1
median	6
Q3	103
95-th percentile	665
Maximum	2001
Range	2350
Interquartile range (IQR)	102

Descriptive statistics

Standard deviation	239.8539224
Coefficient of variation (CV)	2.082718716
Kurtosis	9.866476349
Mean	115.163858
Median Absolute Deviation (MAD)	6
Skewness	2.983115349
Sum	63895442
Variance	57529.90408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122379	22.1%
1	70291	12.7%
2	32699	5.9%
3	20925	3.8%
4	15431	2.8%
5	11773	2.1%
6	10439	1.9%
7	9029	1.6%
8	7752	1.4%
9	6119	1.1%
Other values (1963)	247985	44.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-349	1	< 0.1%
-347	1	< 0.1%
-338	1	< 0.1%
-308	1	< 0.1%
-298	1	< 0.1%
-295	1	< 0.1%
-288	1	< 0.1%
-273	1	< 0.1%
-269	1	< 0.1%
-268	1	< 0.1%

Value	Count	Frequency (%)
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%
1976	1	< 0.1%

year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.692709

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2013
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9277205842
Coefficient of variation (CV)	0.000460935035
Kurtosis	-0.3213344358
Mean	2012.692709
Median Absolute Deviation (MAD)	1
Skewness	-0.368153838
Sum	1116686194
Variance	0.8606654823
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	224563	40.5%
2012	162933	29.4%
2014	111093	20.0%
2011	50056	9.0%
2010	6168	1.1%
2009	9	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	9	< 0.1%
2010	6168	1.1%
2011	50056	9.0%
2012	162933	29.4%
2013	224563	40.5%
2014	111093	20.0%

Value	Count	Frequency (%)
2014	111093	20.0%
2013	224563	40.5%
2012	162933	29.4%
2011	50056	9.0%
2010	6168	1.1%
2009	9	< 0.1%

month_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.807932995

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.067627605
Coefficient of variation (CV)	0.5281788905
Kurtosis	-0.8693851241
Mean	5.807932995
Median Absolute Deviation (MAD)	2
Skewness	0.2746715861
Sum	3222369
Variance	9.410339125
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	75346	13.6%
6	71619	12.9%
4	62369	11.2%
3	51841	9.3%
2	46169	8.3%
8	44135	8.0%
1	44064	7.9%
9	41154	7.4%
7	33804	6.1%
10	32591	5.9%
Other values (2)	51730	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	44064	7.9%
2	46169	8.3%
3	51841	9.3%
4	62369	11.2%
5	75346	13.6%
6	71619	12.9%
7	33804	6.1%
8	44135	8.0%
9	41154	7.4%
10	32591	5.9%

Value	Count	Frequency (%)
12	19490	3.5%
11	32240	5.8%
10	32591	5.9%
9	41154	7.4%
8	44135	8.0%
7	33804	6.1%
6	71619	12.9%
5	75346	13.6%
4	62369	11.2%
3	51841	9.3%

day_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.51307807

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.421955108
Coefficient of variation (CV)	0.5428938778
Kurtosis	-1.178646631
Mean	15.51307807
Median Absolute Deviation (MAD)	7
Skewness	-0.001275577787
Sum	8606997
Variance	70.92932785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
22	20315	3.7%
24	20284	3.7%
23	20096	3.6%
13	19804	3.6%
16	19757	3.6%
27	19726	3.6%
3	19643	3.5%
15	19333	3.5%
18	19184	3.5%
21	19173	3.5%
Other values (21)	357507	64.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12964	2.3%
2	16335	2.9%
3	19643	3.5%
4	18862	3.4%
5	18939	3.4%
6	18732	3.4%
7	19010	3.4%
8	18728	3.4%
9	19097	3.4%
10	19152	3.5%

Value	Count	Frequency (%)
31	2858	0.5%
30	11470	2.1%
29	14889	2.7%
28	17583	3.2%
27	19726	3.6%
26	18450	3.3%
25	19050	3.4%
24	20284	3.7%
23	20096	3.6%
22	20315	3.7%

day_of_week_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.439645508

Minimum	0
Maximum	6
Zeros	86787
Zeros (%)	15.6%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.730416008
Coefficient of variation (CV)	0.7092899368
Kurtosis	-0.9192544035
Mean	2.439645508
Median Absolute Deviation (MAD)	1
Skewness	0.274435407
Sum	1353569
Variance	2.994339561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	107192	19.3%
1	105135	18.9%
3	94722	17.1%
0	86787	15.6%
4	79003	14.2%
5	58026	10.5%
6	23957	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	86787	15.6%
1	105135	18.9%
2	107192	19.3%
3	94722	17.1%
4	79003	14.2%
5	58026	10.5%
6	23957	4.3%

Value	Count	Frequency (%)
6	23957	4.3%
5	58026	10.5%
4	79003	14.2%
3	94722	17.1%
2	107192	19.3%
1	105135	18.9%
0	86787	15.6%

week_of_year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.03364322

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.31143732
Coefficient of variation (CV)	0.5538668108
Kurtosis	-0.8753861051
Mean	24.03364322
Median Absolute Deviation (MAD)	10
Skewness	0.2732430855
Sum	13334394
Variance	177.1943636
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	18862	3.4%
21	17613	3.2%
19	17287	3.1%
25	17251	3.1%
24	17035	3.1%
20	17028	3.1%
26	16991	3.1%
18	15764	2.8%
22	15511	2.8%
17	15159	2.7%
Other values (43)	386321	69.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5896	1.1%
2	6530	1.2%
3	10144	1.8%
4	10302	1.9%
5	9530	1.7%
6	11530	2.1%
7	11450	2.1%
8	11682	2.1%
9	11470	2.1%
10	11924	2.1%

Value	Count	Frequency (%)
53	2	< 0.1%
52	3305	0.6%
51	5236	0.9%
50	6236	1.1%
49	7096	1.3%
48	6394	1.2%
47	7579	1.4%
46	8339	1.5%
45	8227	1.5%
44	6880	1.2%

year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.999165

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	2010
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.113669869
Coefficient of variation (CV)	0.0005532391111
Kurtosis	-0.3835469917
Mean	2012.999165
Median Absolute Deviation (MAD)	1
Skewness	0.006615507521
Sum	1116856223
Variance	1.240260577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	202756	36.5%
2012	137610	24.8%
2014	110797	20.0%
2015	59671	10.8%
2011	38972	7.0%
2010	5016	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	5016	0.9%
2011	38972	7.0%
2012	137610	24.8%
2013	202756	36.5%
2014	110797	20.0%
2015	59671	10.8%

Value	Count	Frequency (%)
2015	59671	10.8%
2014	110797	20.0%
2013	202756	36.5%
2012	137610	24.8%
2011	38972	7.0%
2010	5016	0.9%

month_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.899670525

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.796555175
Coefficient of variation (CV)	0.4740188732
Kurtosis	-0.5926744518
Mean	5.899670525
Median Absolute Deviation (MAD)	2
Skewness	0.2059007341
Sum	3273267
Variance	7.820720845
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	123243	22.2%
5	67843	12.2%
4	52103	9.4%
3	45645	8.2%
8	43818	7.9%
7	40280	7.3%
2	40204	7.2%
9	38519	6.9%
1	32810	5.9%
10	30383	5.5%
Other values (2)	39974	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	32810	5.9%
2	40204	7.2%
3	45645	8.2%
4	52103	9.4%
5	67843	12.2%
6	123243	22.2%
7	40280	7.3%
8	43818	7.9%
9	38519	6.9%
10	30383	5.5%

Value	Count	Frequency (%)
12	13310	2.4%
11	26664	4.8%
10	30383	5.5%
9	38519	6.9%
8	43818	7.9%
7	40280	7.3%
6	123243	22.2%
5	67843	12.2%
4	52103	9.4%
3	45645	8.2%

day_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.55563226

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	17
Q3	25
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	8.882690308
Coefficient of variation (CV)	0.536535855
Kurtosis	-1.249593904
Mean	16.55563226
Median Absolute Deviation (MAD)	8
Skewness	-0.07880975466
Sum	9185429
Variance	78.90218711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
29	66907	12.1%
15	18764	3.4%
5	18441	3.3%
16	18380	3.3%
17	18161	3.3%
23	18084	3.3%
4	17854	3.2%
11	17826	3.2%
9	17689	3.2%
13	17606	3.2%
Other values (21)	325110	58.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13073	2.4%
2	15027	2.7%
3	16969	3.1%
4	17854	3.2%
5	18441	3.3%
6	17026	3.1%
7	16618	3.0%
8	16778	3.0%
9	17689	3.2%
10	17263	3.1%

Value	Count	Frequency (%)
31	2045	0.4%
30	7912	1.4%
29	66907	12.1%
28	14280	2.6%
27	15244	2.7%
26	15743	2.8%
25	17490	3.2%
24	17523	3.2%
23	18084	3.3%
22	17539	3.2%

day_of_week_first_booking
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.200473305

Minimum	0
Maximum	6
Zeros	124075
Zeros (%)	22.4%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.738417998
Coefficient of variation (CV)	0.7900200355
Kurtosis	-0.9319808208
Mean	2.200473305
Median Absolute Deviation (MAD)	1
Skewness	0.3440031114
Sum	1220871
Variance	3.022097137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	124075	22.4%
2	101856	18.4%
1	97008	17.5%
3	90899	16.4%
4	74110	13.4%
5	50230	9.1%
6	16644	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	124075	22.4%
1	97008	17.5%
2	101856	18.4%
3	90899	16.4%
4	74110	13.4%
5	50230	9.1%
6	16644	3.0%

Value	Count	Frequency (%)
6	16644	3.0%
5	50230	9.1%
4	74110	13.4%
3	90899	16.4%
2	101856	18.4%
1	97008	17.5%
0	124075	22.4%

week_of_year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.67367372

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	25
Q3	33
95-th percentile	46
Maximum	52
Range	51
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	12.19191992
Coefficient of variation (CV)	0.4941266572
Kurtosis	-0.6307787703
Mean	24.67367372
Median Absolute Deviation (MAD)	9
Skewness	0.154249366
Sum	13689497
Variance	148.6429112
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	66367	12.0%
24	17626	3.2%
23	17089	3.1%
21	16538	3.0%
25	15858	2.9%
26	15322	2.8%
20	14949	2.7%
19	14893	2.7%
22	13908	2.5%
18	13788	2.5%
Other values (42)	348484	62.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4203	0.8%
2	4831	0.9%
3	7850	1.4%
4	8075	1.5%
5	7387	1.3%
6	9146	1.6%
7	9753	1.8%
8	10274	1.9%
9	9929	1.8%
10	10616	1.9%

Value	Count	Frequency (%)
52	1808	0.3%
51	3927	0.7%
50	4824	0.9%
49	5719	1.0%
48	5329	1.0%
47	5931	1.1%
46	6672	1.2%
45	7077	1.3%
44	5760	1.0%
43	6278	1.1%

year_account_created
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

2013	224619
2012	162945
2014	111134
2011	49995
2010	6129

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2219288
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2011
2nd row	2010
3rd row	2011
4th row	2010
5th row	2010

Common Values

Value	Count	Frequency (%)
2013	224619	40.5%
2012	162945	29.4%
2014	111134	20.0%
2011	49995	9.0%
2010	6129	1.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2013	224619	40.5%
2012	162945	29.4%
2014	111134	20.0%
2011	49995	9.0%
2010	6129	1.1%

Most occurring characters

Value	Count	Frequency (%)
2	717767	32.3%
1	604817	27.3%
0	560951	25.3%
3	224619	10.1%
4	111134	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2219288	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	717767	32.3%
1	604817	27.3%
0	560951	25.3%
3	224619	10.1%
4	111134	5.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2219288	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	717767	32.3%
1	604817	27.3%
0	560951	25.3%
3	224619	10.1%
4	111134	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2219288	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	717767	32.3%
1	604817	27.3%
0	560951	25.3%
3	224619	10.1%
4	111134	5.0%

month_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.809180242

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.068355187
Coefficient of variation (CV)	0.5281907359
Kurtosis	-0.8703270809
Mean	5.809180242
Median Absolute Deviation (MAD)	2
Skewness	0.2740977688
Sum	3223061
Variance	9.414803552
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	75316	13.6%
6	71584	12.9%
4	62329	11.2%
3	51820	9.3%
2	46147	8.3%
8	44152	8.0%
1	44083	7.9%
9	41159	7.4%
7	33820	6.1%
10	32590	5.9%
Other values (2)	51822	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	44083	7.9%
2	46147	8.3%
3	51820	9.3%
4	62329	11.2%
5	75316	13.6%
6	71584	12.9%
7	33820	6.1%
8	44152	8.0%
9	41159	7.4%
10	32590	5.9%

Value	Count	Frequency (%)
12	19495	3.5%
11	32327	5.8%
10	32590	5.9%
9	41159	7.4%
8	44152	8.0%
7	33820	6.1%
6	71584	12.9%
5	75316	13.6%
4	62329	11.2%
3	51820	9.3%

day_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.51491109

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.422993585
Coefficient of variation (CV)	0.5428966713
Kurtosis	-1.178968574
Mean	15.51491109
Median Absolute Deviation (MAD)	7
Skewness	-0.001614584424
Sum	8608014
Variance	70.94682094
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
22	20325	3.7%
24	20306	3.7%
23	20060	3.6%
13	19783	3.6%
16	19780	3.6%
27	19739	3.6%
3	19649	3.5%
15	19324	3.5%
18	19185	3.5%
10	19165	3.5%
Other values (21)	357506	64.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12969	2.3%
2	16337	2.9%
3	19649	3.5%
4	18866	3.4%
5	18931	3.4%
6	18713	3.4%
7	19002	3.4%
8	18730	3.4%
9	19114	3.4%
10	19165	3.5%

Value	Count	Frequency (%)
31	2857	0.5%
30	11463	2.1%
29	14883	2.7%
28	17651	3.2%
27	19739	3.6%
26	18450	3.3%
25	19054	3.4%
24	20306	3.7%
23	20060	3.6%
22	20325	3.7%

day_of _week_first_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.439924877

Minimum	0
Maximum	6
Zeros	86744
Zeros (%)	15.6%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.730548632
Coefficient of variation (CV)	0.7092630795
Kurtosis	-0.9196450026
Mean	2.439924877
Median Absolute Deviation (MAD)	1
Skewness	0.2744991132
Sum	1353724
Variance	2.994798568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	107256	19.3%
1	105165	19.0%
3	94577	17.0%
0	86744	15.6%
4	79052	14.2%
5	58060	10.5%
6	23968	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	86744	15.6%
1	105165	19.0%
2	107256	19.3%
3	94577	17.0%
4	79052	14.2%
5	58060	10.5%
6	23968	4.3%

Value	Count	Frequency (%)
6	23968	4.3%
5	58060	10.5%
4	79052	14.2%
3	94577	17.0%
2	107256	19.3%
1	105165	19.0%
0	86744	15.6%

week_of _year_first_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.03956044

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.31524146
Coefficient of variation (CV)	0.5538887242
Kurtosis	-0.8765677966
Mean	24.03956044
Median Absolute Deviation (MAD)	10
Skewness	0.2726658434
Sum	13337677
Variance	177.2956552
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	18859	3.4%
21	17617	3.2%
19	17269	3.1%
25	17245	3.1%
24	17028	3.1%
20	16997	3.1%
26	16985	3.1%
18	15766	2.8%
22	15523	2.8%
17	15159	2.7%
Other values (43)	386374	69.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5898	1.1%
2	6531	1.2%
3	10142	1.8%
4	10303	1.9%
5	9540	1.7%
6	11533	2.1%
7	11455	2.1%
8	11676	2.1%
9	11466	2.1%
10	11914	2.1%

Value	Count	Frequency (%)
53	2	< 0.1%
52	3306	0.6%
51	5237	0.9%
50	6237	1.1%
49	7098	1.3%
48	6396	1.2%
47	7642	1.4%
46	8357	1.5%
45	8232	1.5%
44	6888	1.2%

gender
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

FEMALE	246792
MALE	220601
-unknown-	85802
OTHER	1627

Length

Max length	9
Median length	6
Mean length	5.665797319
Min length	4

Characters and Unicode

Total characters	3143509
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MALE
2nd row	FEMALE
3rd row	FEMALE
4th row	-unknown-
5th row	FEMALE

Common Values

Value	Count	Frequency (%)
FEMALE	246792	44.5%
MALE	220601	39.8%
-unknown-	85802	15.5%
OTHER	1627	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
female	246792	44.5%
male	220601	39.8%
unknown	85802	15.5%
other	1627	0.3%

Most occurring characters

Value	Count	Frequency (%)
E	715812	22.8%
M	467393	14.9%
A	467393	14.9%
L	467393	14.9%
n	257406	8.2%
F	246792	7.9%
-	171604	5.5%
u	85802	2.7%
k	85802	2.7%
o	85802	2.7%
Other values (5)	92310	2.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2371291	75.4%
Lowercase Letter	600614	19.1%
Dash Punctuation	171604	5.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	715812	30.2%
M	467393	19.7%
A	467393	19.7%
L	467393	19.7%
F	246792	10.4%
O	1627	0.1%
T	1627	0.1%
H	1627	0.1%
R	1627	0.1%

Lowercase Letter

Value	Count	Frequency (%)
n	257406	42.9%
u	85802	14.3%
k	85802	14.3%
o	85802	14.3%
w	85802	14.3%

Dash Punctuation

Value	Count	Frequency (%)
-	171604	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2971905	94.5%
Common	171604	5.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	715812	24.1%
M	467393	15.7%
A	467393	15.7%
L	467393	15.7%
n	257406	8.7%
F	246792	8.3%
u	85802	2.9%
k	85802	2.9%
o	85802	2.9%
w	85802	2.9%
Other values (4)	6508	0.2%

Common

Value	Count	Frequency (%)
-	171604	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3143509	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	715812	22.8%
M	467393	14.9%
A	467393	14.9%
L	467393	14.9%
n	257406	8.2%
F	246792	7.9%
-	171604	5.5%
u	85802	2.7%
k	85802	2.7%
o	85802	2.7%
Other values (5)	92310	2.9%

signup_method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

basic	348063
facebook	206245
google	514

Length

Max length	8
Median length	5
Mean length	6.116121927
Min length	5

Characters and Unicode

Total characters	3393359
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	basic
3rd row	facebook
4th row	basic
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	348063	62.7%
facebook	206245	37.2%
google	514	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
basic	348063	62.7%
facebook	206245	37.2%
google	514	0.1%

Most occurring characters

Value	Count	Frequency (%)
b	554308	16.3%
a	554308	16.3%
c	554308	16.3%
o	413518	12.2%
s	348063	10.3%
i	348063	10.3%
e	206759	6.1%
f	206245	6.1%
k	206245	6.1%
g	1028	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3393359	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
b	554308	16.3%
a	554308	16.3%
c	554308	16.3%
o	413518	12.2%
s	348063	10.3%
i	348063	10.3%
e	206759	6.1%
f	206245	6.1%
k	206245	6.1%
g	1028	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3393359	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
b	554308	16.3%
a	554308	16.3%
c	554308	16.3%
o	413518	12.2%
s	348063	10.3%
i	348063	10.3%
e	206759	6.1%
f	206245	6.1%
k	206245	6.1%
g	1028	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3393359	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
b	554308	16.3%
a	554308	16.3%
c	554308	16.3%
o	413518	12.2%
s	348063	10.3%
i	348063	10.3%
e	206759	6.1%
f	206245	6.1%
k	206245	6.1%
g	1028	< 0.1%

language
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

en	539744
fr	3573
es	2504
de	2425
zh	1775
Other values (20)	4801

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1109644
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	539744	97.3%
fr	3573	0.6%
es	2504	0.5%
de	2425	0.4%
zh	1775	0.3%
it	1047	0.2%
ko	970	0.2%
ru	706	0.1%
pt	380	0.1%
nl	375	0.1%
Other values (15)	1323	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	539744	97.3%
fr	3573	0.6%
es	2504	0.5%
de	2425	0.4%
zh	1775	0.3%
it	1047	0.2%
ko	970	0.2%
ru	706	0.1%
pt	380	0.1%
nl	375	0.1%
Other values (15)	1323	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	544766	49.1%
n	540193	48.7%
r	4392	0.4%
f	3605	0.3%
s	2860	0.3%
d	2557	0.2%
h	1811	0.2%
z	1775	0.2%
t	1555	0.1%
i	1105	0.1%
Other values (9)	5025	0.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1109644	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	544766	49.1%
n	540193	48.7%
r	4392	0.4%
f	3605	0.3%
s	2860	0.3%
d	2557	0.2%
h	1811	0.2%
z	1775	0.2%
t	1555	0.1%
i	1105	0.1%
Other values (9)	5025	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1109644	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	544766	49.1%
n	540193	48.7%
r	4392	0.4%
f	3605	0.3%
s	2860	0.3%
d	2557	0.2%
h	1811	0.2%
z	1775	0.2%
t	1555	0.1%
i	1105	0.1%
Other values (9)	5025	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1109644	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	544766	49.1%
n	540193	48.7%
r	4392	0.4%
f	3605	0.3%
s	2860	0.3%
d	2557	0.2%
h	1811	0.2%
z	1775	0.2%
t	1555	0.1%
i	1105	0.1%
Other values (9)	5025	0.5%

affiliate_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

direct	369212
sem-brand	74104
sem-non-brand	48327
seo	24541
other	16198
Other values (3)	22440

Length

Max length	13
Median length	6
Mean length	6.807776188
Min length	3

Characters and Unicode

Total characters	3777104
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	seo
2nd row	direct
3rd row	direct
4th row	direct
5th row	other

Common Values

Value	Count	Frequency (%)
direct	369212	66.5%
sem-brand	74104	13.4%
sem-non-brand	48327	8.7%
seo	24541	4.4%
other	16198	2.9%
api	13988	2.5%
content	5726	1.0%
remarketing	2726	0.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
direct	369212	66.5%
sem-brand	74104	13.4%
sem-non-brand	48327	8.7%
seo	24541	4.4%
other	16198	2.9%
api	13988	2.5%
content	5726	1.0%
remarketing	2726	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	543560	14.4%
r	513293	13.6%
d	491643	13.0%
t	399588	10.6%
i	385926	10.2%
c	374938	9.9%
n	233263	6.2%
-	170758	4.5%
s	146972	3.9%
a	139145	3.7%
Other values (7)	378018	10.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3606346	95.5%
Dash Punctuation	170758	4.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	543560	15.1%
r	513293	14.2%
d	491643	13.6%
t	399588	11.1%
i	385926	10.7%
c	374938	10.4%
n	233263	6.5%
s	146972	4.1%
a	139145	3.9%
m	125157	3.5%
Other values (6)	252861	7.0%

Dash Punctuation

Value	Count	Frequency (%)
-	170758	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3606346	95.5%
Common	170758	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	543560	15.1%
r	513293	14.2%
d	491643	13.6%
t	399588	11.1%
i	385926	10.7%
c	374938	10.4%
n	233263	6.5%
s	146972	4.1%
a	139145	3.9%
m	125157	3.5%
Other values (6)	252861	7.0%

Common

Value	Count	Frequency (%)
-	170758	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3777104	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	543560	14.4%
r	513293	13.6%
d	491643	13.0%
t	399588	10.6%
i	385926	10.2%
c	374938	9.9%
n	233263	6.2%
-	170758	4.5%
s	146972	3.9%
a	139145	3.7%
Other values (7)	378018	10.0%

affiliate_provider
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

direct	368194
google	139247
other	22501
facebook	6916
craigslist	6349
Other values (12)	11615

Length

Max length	19
Median length	6
Mean length	6.051560681
Min length	3

Characters and Unicode

Total characters	3357539
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	google
2nd row	direct
3rd row	direct
4th row	direct
5th row	craigslist

Common Values

Value	Count	Frequency (%)
direct	368194	66.4%
google	139247	25.1%
other	22501	4.1%
facebook	6916	1.2%
craigslist	6349	1.1%
bing	5678	1.0%
facebook-open-graph	1739	0.3%
vast	1371	0.2%
padmapper	972	0.2%
yahoo	755	0.1%
Other values (7)	1100	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	368194	66.4%
google	139247	25.1%
other	22501	4.1%
facebook	6916	1.2%
craigslist	6349	1.1%
bing	5678	1.0%
facebook-open-graph	1739	0.3%
vast	1371	0.2%
padmapper	972	0.2%
yahoo	755	0.1%
Other values (7)	1100	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	542628	16.2%
r	400096	11.9%
t	399031	11.9%
i	387137	11.5%
c	383198	11.4%
d	369213	11.0%
o	321554	9.6%
g	292887	8.7%
l	145863	4.3%
h	24995	0.7%
Other values (14)	90937	2.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3353794	99.9%
Dash Punctuation	3745	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	542628	16.2%
r	400096	11.9%
t	399031	11.9%
i	387137	11.5%
c	383198	11.4%
d	369213	11.0%
o	321554	9.6%
g	292887	8.7%
l	145863	4.3%
h	24995	0.7%
Other values (13)	87192	2.6%

Dash Punctuation

Value	Count	Frequency (%)
-	3745	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3353794	99.9%
Common	3745	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	542628	16.2%
r	400096	11.9%
t	399031	11.9%
i	387137	11.5%
c	383198	11.4%
d	369213	11.0%
o	321554	9.6%
g	292887	8.7%
l	145863	4.3%
h	24995	0.7%
Other values (13)	87192	2.6%

Common

Value	Count	Frequency (%)
-	3745	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3357539	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	542628	16.2%
r	400096	11.9%
t	399031	11.9%
i	387137	11.5%
c	383198	11.4%
d	369213	11.0%
o	321554	9.6%
g	292887	8.7%
l	145863	4.3%
h	24995	0.7%
Other values (14)	90937	2.7%

first_affiliate_tracked
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

untracked	303301
linked	121916
omg	112953
tracked-other	12471
product	3857
Other values (2)	324

Length

Max length	13
Median length	9
Mean length	7.195284253
Min length	3

Characters and Unicode

Total characters	3992102
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	untracked
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	303301	54.7%
linked	121916	22.0%
omg	112953	20.4%
tracked-other	12471	2.2%
product	3857	0.7%
marketing	241	< 0.1%
local ops	83	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
untracked	303301	54.7%
linked	121916	22.0%
omg	112953	20.4%
tracked-other	12471	2.2%
product	3857	0.7%
marketing	241	< 0.1%
local	83	< 0.1%
ops	83	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	450400	11.3%
d	441545	11.1%
k	437929	11.0%
n	425458	10.7%
t	332341	8.3%
r	332341	8.3%
c	319712	8.0%
a	316096	7.9%
u	307158	7.7%
o	129447	3.2%
Other values (9)	499675	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3979548	99.7%
Dash Punctuation	12471	0.3%
Space Separator	83	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	450400	11.3%
d	441545	11.1%
k	437929	11.0%
n	425458	10.7%
t	332341	8.4%
r	332341	8.4%
c	319712	8.0%
a	316096	7.9%
u	307158	7.7%
o	129447	3.3%
Other values (7)	487121	12.2%

Dash Punctuation

Value	Count	Frequency (%)
-	12471	100.0%

Space Separator

Value	Count	Frequency (%)
	83	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3979548	99.7%
Common	12554	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	450400	11.3%
d	441545	11.1%
k	437929	11.0%
n	425458	10.7%
t	332341	8.4%
r	332341	8.4%
c	319712	8.0%
a	316096	7.9%
u	307158	7.7%
o	129447	3.3%
Other values (7)	487121	12.2%

Common

Value	Count	Frequency (%)
-	12471	99.3%
	83	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3992102	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	450400	11.3%
d	441545	11.1%
k	437929	11.0%
n	425458	10.7%
t	332341	8.3%
r	332341	8.3%
c	319712	8.0%
a	316096	7.9%
u	307158	7.7%
o	129447	3.2%
Other values (9)	499675	12.5%

signup_app
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Web	512969
iOS	28268
Moweb	7764
Android	5821

Length

Max length	7
Median length	3
Mean length	3.069953967
Min length	3

Characters and Unicode

Total characters	1703278
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	512969	92.5%
iOS	28268	5.1%
Moweb	7764	1.4%
Android	5821	1.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
web	512969	92.5%
ios	28268	5.1%
moweb	7764	1.4%
android	5821	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	520733	30.6%
b	520733	30.6%
W	512969	30.1%
i	34089	2.0%
O	28268	1.7%
S	28268	1.7%
o	13585	0.8%
d	11642	0.7%
M	7764	0.5%
w	7764	0.5%
Other values (3)	17463	1.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1120188	65.8%
Uppercase Letter	583090	34.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	520733	46.5%
b	520733	46.5%
i	34089	3.0%
o	13585	1.2%
d	11642	1.0%
w	7764	0.7%
n	5821	0.5%
r	5821	0.5%

Uppercase Letter

Value	Count	Frequency (%)
W	512969	88.0%
O	28268	4.8%
S	28268	4.8%
M	7764	1.3%
A	5821	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1703278	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	520733	30.6%
b	520733	30.6%
W	512969	30.1%
i	34089	2.0%
O	28268	1.7%
S	28268	1.7%
o	13585	0.8%
d	11642	0.7%
M	7764	0.5%
w	7764	0.5%
Other values (3)	17463	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1703278	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	520733	30.6%
b	520733	30.6%
W	512969	30.1%
i	34089	2.0%
O	28268	1.7%
S	28268	1.7%
o	13585	0.8%
d	11642	0.7%
M	7764	0.5%
w	7764	0.5%
Other values (3)	17463	1.0%

first_device_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Mac Desktop	287424
Windows Desktop	184099
iPad	35356
iPhone	32453
Other/Unknown	6024
Other values (4)	9466

Length

Max length	18
Median length	11
Mean length	11.66327038
Min length	4

Characters and Unicode

Total characters	6471039
Distinct characters	30
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mac Desktop
2nd row	Windows Desktop
3rd row	Mac Desktop
4th row	Mac Desktop
5th row	Mac Desktop

Common Values

Value	Count	Frequency (%)
Mac Desktop	287424	51.8%
Windows Desktop	184099	33.2%
iPad	35356	6.4%
iPhone	32453	5.8%
Other/Unknown	6024	1.1%
Desktop (Other)	3714	0.7%
Android Phone	3066	0.6%
Android Tablet	2620	0.5%
SmartPhone (Other)	66	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
desktop	475237	45.9%
mac	287424	27.7%
windows	184099	17.8%
ipad	35356	3.4%
iphone	32453	3.1%
other/unknown	6024	0.6%
android	5686	0.5%
other	3780	0.4%
phone	3066	0.3%
tablet	2620	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	706631	10.9%
s	659336	10.2%
e	523246	8.1%
t	487727	7.5%
k	481261	7.4%
	480989	7.4%
D	475237	7.3%
p	475237	7.3%
a	325466	5.0%
M	287424	4.4%
Other values (20)	1568485	24.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4934565	76.3%
Uppercase Letter	1041901	16.1%
Space Separator	480989	7.4%
Other Punctuation	6024	0.1%
Open Punctuation	3780	0.1%
Close Punctuation	3780	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	706631	14.3%
s	659336	13.4%
e	523246	10.6%
t	487727	9.9%
k	481261	9.8%
p	475237	9.6%
a	325466	6.6%
c	287424	5.8%
i	257594	5.2%
n	243442	4.9%
Other values (7)	487201	9.9%

Uppercase Letter

Value	Count	Frequency (%)
D	475237	45.6%
M	287424	27.6%
W	184099	17.7%
P	70941	6.8%
O	9804	0.9%
U	6024	0.6%
A	5686	0.5%
T	2620	0.3%
S	66	< 0.1%

Space Separator

Value	Count	Frequency (%)
	480989	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	6024	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3780	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3780	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5976466	92.4%
Common	494573	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	706631	11.8%
s	659336	11.0%
e	523246	8.8%
t	487727	8.2%
k	481261	8.1%
D	475237	8.0%
p	475237	8.0%
a	325466	5.4%
M	287424	4.8%
c	287424	4.8%
Other values (16)	1267477	21.2%

Common

Value	Count	Frequency (%)
	480989	97.3%
/	6024	1.2%
(	3780	0.8%
)	3780	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6471039	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	706631	10.9%
s	659336	10.2%
e	523246	8.1%
t	487727	7.5%
k	481261	7.4%
	480989	7.4%
D	475237	7.3%
p	475237	7.3%
a	325466	5.0%
M	287424	4.4%
Other values (20)	1568485	24.2%

first_browser
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Chrome	193752
Safari	136078
Firefox	100149
IE	45748
Mobile Safari	42756
Other values (36)	36339

Length

Max length	18
Median length	6
Mean length	6.611925987
Min length	2

Characters and Unicode

Total characters	3668442
Distinct characters	46
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	IE
3rd row	Firefox
4th row	Chrome
5th row	Safari

Common Values

Value	Count	Frequency (%)
Chrome	193752	34.9%
Safari	136078	24.5%
Firefox	100149	18.1%
IE	45748	8.2%
Mobile Safari	42756	7.7%
-unknown-	31231	5.6%
Chrome Mobile	2144	0.4%
Android Browser	1143	0.2%
Opera	417	0.1%
Chromium	286	0.1%
Other values (31)	1118	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	195896	32.6%
safari	178834	29.7%
firefox	100188	16.7%
ie	45761	7.6%
mobile	44954	7.5%
unknown	31231	5.2%
browser	1236	0.2%
android	1143	0.2%
opera	421	0.1%
chromium	286	< 0.1%
Other values (33)	1435	0.2%

Most occurring characters

Value	Count	Frequency (%)
r	480009	13.1%
o	375836	10.2%
a	358450	9.8%
e	343556	9.4%
i	325739	8.9%
f	279022	7.6%
m	196478	5.4%
h	196267	5.4%
C	196239	5.3%
S	179086	4.9%
Other values (36)	737760	20.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2942613	80.2%
Uppercase Letter	616793	16.8%
Dash Punctuation	62462	1.7%
Space Separator	46563	1.3%
Other Punctuation	11	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	480009	16.3%
o	375836	12.8%
a	358450	12.2%
e	343556	11.7%
i	325739	11.1%
f	279022	9.5%
m	196478	6.7%
h	196267	6.7%
x	100541	3.4%
n	95071	3.2%
Other values (14)	191644	6.5%

Uppercase Letter

Value	Count	Frequency (%)
C	196239	31.8%
S	179086	29.0%
F	100208	16.2%
E	46023	7.5%
I	45871	7.4%
M	45291	7.3%
A	1493	0.2%
B	1373	0.2%
O	663	0.1%
L	240	< 0.1%
Other values (9)	306	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	62462	100.0%

Space Separator

Value	Count	Frequency (%)
	46563	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	11	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3559406	97.0%
Common	109036	3.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	480009	13.5%
o	375836	10.6%
a	358450	10.1%
e	343556	9.7%
i	325739	9.2%
f	279022	7.8%
m	196478	5.5%
h	196267	5.5%
C	196239	5.5%
S	179086	5.0%
Other values (33)	628724	17.7%

Common

Value	Count	Frequency (%)
-	62462	57.3%
	46563	42.7%
.	11	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3668442	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	480009	13.1%
o	375836	10.2%
a	358450	9.8%
e	343556	9.4%
i	325739	8.9%
f	279022	7.6%
m	196478	5.4%
h	196267	5.4%
C	196239	5.3%
S	179086	4.9%
Other values (36)	737760	20.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	age	signup_flow	days_from_first_active_until_booking	days_from_first_active_until_account_created	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of _week_first_account_created	week_of _year_first_account_created	gender	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser
0	38	0	2228	732	1496	2009	5	23	5	21	2015	6	29	0	27	2011	5	25	2	21	MALE	facebook	en	seo	google	untracked	Web	Mac Desktop	Chrome
1	56	3	419	476	-57	2009	6	9	1	24	2010	8	2	0	31	2010	9	28	1	39	FEMALE	basic	en	direct	direct	untracked	Web	Windows Desktop	IE
2	42	0	1043	765	278	2009	10	31	5	44	2012	9	8	5	36	2011	12	5	0	49	FEMALE	facebook	en	direct	direct	untracked	Web	Mac Desktop	Firefox
3	41	0	72	280	-208	2009	12	8	1	50	2010	2	18	3	7	2010	9	14	1	37	-unknown-	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome
4	46	0	3	0	3	2010	1	2	5	53	2010	1	5	1	1	2010	1	2	5	53	FEMALE	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari
5	47	0	10	0	10	2010	1	3	6	53	2010	1	13	2	2	2010	1	3	6	53	FEMALE	basic	en	direct	direct	omg	Web	Mac Desktop	Safari
6	50	0	206	0	206	2010	1	4	0	1	2010	7	29	3	30	2010	1	4	0	1	FEMALE	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari
7	46	0	0	0	0	2010	1	4	0	1	2010	1	4	0	1	2010	1	4	0	1	-unknown-	basic	en	other	craigslist	omg	Web	Mac Desktop	Firefox
8	36	0	2	0	2	2010	1	4	0	1	2010	1	6	2	1	2010	1	4	0	1	FEMALE	basic	en	other	craigslist	untracked	Web	Mac Desktop	Firefox
9	47	0	2001	0	2001	2010	1	5	1	1	2015	6	29	0	27	2010	1	5	1	1	FEMALE	basic	en	other	craigslist	untracked	Web	iPhone	-unknown-

Last rows

	age	signup_flow	days_from_first_active_until_booking	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of _week_first_account_created	week_of _year_first_account_created	gender	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser
554812	46	0	172	172	2014	1	9	6	5	2014	7	27	2	30	2014	1	9	6	5	MALE	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome
554813	25	0	0	0	2013	12	17	1	51	2013	12	17	1	51	2013	12	17	1	51	MALE	basic	en	sem-brand	google	omg	Web	Windows Desktop	Chrome
554814	29	20	73	73	2014	3	4	2	11	2014	5	16	5	21	2014	3	4	2	11	FEMALE	basic	en	direct	direct	untracked	iOS	Mac Desktop	Chrome
554815	31	0	1	1	2013	11	19	1	47	2013	11	20	2	47	2013	11	19	1	47	FEMALE	basic	en	sem-non-brand	google	omg	Web	Windows Desktop	Chrome
554816	40	0	1	1	2012	10	1	0	40	2012	10	2	2	40	2012	10	1	0	40	FEMALE	basic	en	direct	direct	omg	Web	Mac Desktop	Safari
554817	33	0	1	1	2013	3	20	2	12	2013	3	22	4	12	2013	3	20	2	12	FEMALE	basic	en	direct	direct	linked	Web	Mac Desktop	Firefox
554818	34	0	52	52	2012	7	7	0	27	2012	8	29	3	35	2012	7	7	0	27	MALE	facebook	en	direct	direct	linked	Web	Windows Desktop	Firefox
554819	29	0	22	22	2013	5	21	2	21	2013	6	13	3	24	2013	5	21	2	21	-unknown-	basic	en	direct	direct	untracked	Web	Windows Desktop	IE
554820	32	0	3	3	2014	1	13	0	3	2014	1	16	3	3	2014	1	13	0	3	FEMALE	basic	en	direct	direct	linked	Web	Mac Desktop	Safari
554821	39	0	1	1	2011	7	22	5	29	2011	7	23	3	29	2011	7	22	5	29	FEMALE	basic	en	direct	direct	untracked	Web	Windows Desktop	Chrome

Most frequently occurring

	age	days_from_first_active_until_booking	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of _week_first_account_created	week_of _year_first_account_created	gender	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	# duplicates
51421	35	0	0	2013	6	13	5	27	2013	6	13	5	27	2013	6	13	5	27	-unknown-	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	89
33585	31	0	0	2013	6	15	5	24	2013	6	15	5	24	2013	6	15	5	24	FEMALE	facebook	en	direct	direct	untracked	Web	Windows Desktop	Chrome	85
43184	33	0	0	2013	6	15	6	24	2013	6	15	6	24	2013	6	15	6	24	-unknown-	basic	en	sem-brand	google	untracked	Web	Windows Desktop	Chrome	68
38479	32	0	0	2013	6	15	5	24	2013	6	15	5	24	2013	6	15	5	24	-unknown-	basic	en	sem-brand	google	untracked	Web	Windows Desktop	Chrome	66
28021	30	0	0	2012	8	14	2	33	2012	8	14	2	33	2012	8	14	2	33	FEMALE	facebook	en	direct	direct	linked	Web	Mac Desktop	Chrome	65
11409	26	0	0	2013	3	4	0	10	2013	3	5	1	10	2013	3	4	0	10	-unknown-	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	64
47566	34	0	0	2013	6	15	6	24	2013	6	15	6	24	2013	6	15	6	24	-unknown-	basic	en	direct	direct	linked	Web	Mac Desktop	Firefox	63
8336	25	0	0	2013	3	5	1	10	2013	3	6	2	10	2013	3	5	1	10	MALE	facebook	en	sem-brand	google	omg	Web	Windows Desktop	Chrome	62
43884	33	1	1	2013	10	3	3	40	2013	10	4	4	40	2013	10	3	3	40	MALE	basic	en	direct	direct	untracked	Web	Windows Desktop	Chrome	62
54619	36	0	0	2012	6	18	1	24	2012	6	18	1	24	2012	6	18	1	24	FEMALE	facebook	en	direct	direct	omg	Web	Mac Desktop	Safari	60

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script